Lesson 01 – Workshop: Data Analysis
Tell Me Text Box
Smart Lookup
Data Validation
What-If Data Analysis
Forecast Sheet
Makros
Lesson 02 – Workshop: Formulas & Functions
Data Consolidation
Conditional Formatting Worksheet Protection
Managing and Preparing Data
Using Cell References
Lookup, Text and Logical Functions
Statistical and Mathematical Functions
Date and Time Functions
Lesson 03 – Workshop: PivotTables and PivotCharts
PivotTable Basics
PivotTable Options
Formatting a PivotTable
Calculated Items and Fields
Sort & Filter a PivotTable
Consolidated PivotTable
PivotCharts and Sparklines
3D Maps
What you will cover – Lesson Outline Excel On Steroids PLUS
Design meaningful Dashboard Reports catering to your audience’s requirements and goals following Dashboard design best practice.
Create dynamic data models which will serve as the back-end of your Dashboard using advanced functions and formula.
Create PivotTables and PivotCharts.
Explore alternative visualisation techniques like sparklines and conditional formatting for at-a-glance analysis.
Create advanced and custom charts.
Create an interactive, macro-charged Dashboard.